Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	2969
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	347.9 KiB
Average record size in memory	120.0 B

Variable types

Numeric	14

Alerts

`avg_basket_size` is highly overall correlated with `avg_ticket` and 3 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`delta_buy_return` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`items_purchased` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`monetary_returns` is highly overall correlated with `number_returns`	High correlation
`number_returns` is highly overall correlated with `monetary_returns`	High correlation
`purchases` is highly overall correlated with `delta_buy_return` and 4 other fields	High correlation
`recency_days` is highly overall correlated with `purchases`	High correlation
`unique_avg_basket` is highly overall correlated with `unique_products_purchased`	High correlation
`unique_products_purchased` is highly overall correlated with `delta_buy_return` and 4 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 47.52624678)	Skewed
`frequency` is highly skewed (γ1 = 24.88049136)	Skewed
`monetary_returns` is highly skewed (γ1 = 51.677877)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.67271661)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`number_returns` has 1481 (49.9%) zeros	Zeros
`monetary_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2024-01-26 13:04:09.688760
Analysis finished	2024-01-26 13:04:50.694301
Duration	41.01 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2969
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.773

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.4
Q1	13799
median	15221
Q3	16768
95-th percentile	17964.6
Maximum	18287
Range	5940
Interquartile range (IQR)	2969

Descriptive statistics

Standard deviation	1718.9903
Coefficient of variation (CV)	0.11256734
Kurtosis	-1.2060947
Mean	15270.773
Median Absolute Deviation (MAD)	1488
Skewness	0.031607859
Sum	45338925
Variance	2954927.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2959)	2959	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2954
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.3217

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.77
Q1	570.96
median	1086.92
Q3	2308.06
95-th percentile	7219.68
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1737.1

Descriptive statistics

Standard deviation	10580.623
Coefficient of variation (CV)	3.8484486
Kurtosis	353.94472
Mean	2749.3217
Median Absolute Deviation (MAD)	672.16
Skewness	16.777556
Sum	8162736.2
Variance	1.1194959 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178.96	2	0.1%
533.33	2	0.1%
889.93	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
331	2	0.1%
Other values (2944)	2949	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.287639

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.756779
Coefficient of variation (CV)	1.2095137
Kurtosis	2.7779627
Mean	64.287639
Median Absolute Deviation (MAD)	26
Skewness	1.7983795
Sum	190870
Variance	6046.1167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2219	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

purchases
Real number (ℝ)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7231391

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8565313
Coefficient of variation (CV)	1.5474954
Kurtosis	190.83445
Mean	5.7231391
Median Absolute Deviation (MAD)	2
Skewness	10.766805
Sum	16992
Variance	78.438147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	785	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

unique_products_purchased
Real number (ℝ)

HIGH CORRELATION

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.72415

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.89641
Coefficient of variation (CV)	2.1992119
Kurtosis	354.86113
Mean	122.72415
Median Absolute Deviation (MAD)	44
Skewness	15.707635
Sum	364368
Variance	72844.071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
35	35	1.2%
29	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2629	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

items_purchased
Real number (ℝ)

HIGH CORRELATION

Distinct	1671
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1608.8525

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	102.4
Q1	296
median	641
Q3	1401
95-th percentile	4407.4
Maximum	196844
Range	196843
Interquartile range (IQR)	1105

Descriptive statistics

Standard deviation	5887.578
Coefficient of variation (CV)	3.6594891
Kurtosis	465.99808
Mean	1608.8525
Median Absolute Deviation (MAD)	422
Skewness	17.858591
Sum	4776683
Variance	34663575
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
246	8	0.3%
272	8	0.3%
84	8	0.3%
260	8	0.3%
288	8	0.3%
1200	7	0.2%
516	7	0.2%
Other values (1661)	2886	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2957
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	421.40904

Minimum	6.2
Maximum	84236.25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	106.69186
Q1	195.26333
median	305.593
Q3	442.735
95-th percentile	921.62714
Maximum	84236.25
Range	84230.05
Interquartile range (IQR)	247.47167

Descriptive statistics

Standard deviation	1614.6022
Coefficient of variation (CV)	3.8314371
Kurtosis	2451.1323
Mean	421.40904
Median Absolute Deviation (MAD)	117.273
Skewness	47.526247
Sum	1251163.4
Variance	2606940.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
162.6075	2	0.1%
189.825	2	0.1%
230.74	2	0.1%
394.5	2	0.1%
145.525	2	0.1%
186.265	2	0.1%
512.72	2	0.1%
199.4	2	0.1%
200.95	2	0.1%
211.32	2	0.1%
Other values (2947)	2949	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
9.14	1	< 0.1%
11.67	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
20.81	1	< 0.1%
26	1	< 0.1%
26.1	1	< 0.1%
28.21666667	1	< 0.1%
28.73142857	1	< 0.1%

Value	Count	Frequency (%)
84236.25	1	< 0.1%
14844.76667	1	< 0.1%
9341.26	1	< 0.1%
6228.2265	1	< 0.1%
4327.621667	1	< 0.1%
4279.71	1	< 0.1%
4229.365	1	< 0.1%
3914.945	1	< 0.1%
3883.985385	1	< 0.1%
3876.916944	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.348511

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.923077
median	48.285714
Q3	85.333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.410256

Descriptive statistics

Standard deviation	63.544929
Coefficient of variation (CV)	0.94352388
Kurtosis	4.8871091
Mean	67.348511
Median Absolute Deviation (MAD)	26.285714
Skewness	2.0627709
Sum	199957.73
Variance	4037.958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
46	17	0.6%
21	17	0.6%
11	17	0.6%
42	16	0.5%
Other values (1248)	2777	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1137973

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088941642
Q1	0.016339869
median	0.025889968
Q3	0.049450549
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.03311068

Descriptive statistics

Standard deviation	0.40815625
Coefficient of variation (CV)	3.5866953
Kurtosis	989.36508
Mean	0.1137973
Median Absolute Deviation (MAD)	0.012191338
Skewness	24.880491
Sum	337.8642
Variance	0.16659153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.5%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.03571428571	13	0.4%
0.07692307692	13	0.4%
Other values (1215)	2636	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

number_returns
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.122937

Minimum	0
Maximum	45
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.2970249
Coefficient of variation (CV)	2.045551
Kurtosis	114.47695
Mean	1.122937
Median Absolute Deviation (MAD)	1
Skewness	8.0245935
Sum	3334
Variance	5.2763234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	1481	49.9%
1	833	28.1%
2	289	9.7%
3	140	4.7%
4	92	3.1%
5	37	1.2%
6	32	1.1%
7	21	0.7%
9	8	0.3%
11	5	0.2%
Other values (13)	31	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
1	833	28.1%
2	289	9.7%
3	140	4.7%
4	92	3.1%
5	37	1.2%
6	32	1.1%
7	21	0.7%
8	5	0.2%
9	8	0.3%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	0.1%
17	1	< 0.1%
15	2	0.1%
14	1	< 0.1%
13	5	0.2%

monetary_returns
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1077
Distinct (%)	36.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	132.42163

Minimum	0
Maximum	168469.6
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.95
Q3	30
95-th percentile	230.742
Maximum	168469.6
Range	168469.6
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	3149.1565
Coefficient of variation (CV)	23.781285
Kurtosis	2754.6213
Mean	132.42163
Median Absolute Deviation (MAD)	0.95
Skewness	51.677877
Sum	393159.82
Variance	9917186.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
4.95	19	0.6%
12.75	17	0.6%
9.95	17	0.6%
15	16	0.5%
5.9	12	0.4%
4.25	10	0.3%
25.5	10	0.3%
3.75	9	0.3%
17	8	0.3%
Other values (1067)	1370	46.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
0.42	2	0.1%
0.65	1	< 0.1%
0.95	1	< 0.1%
1.25	4	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.2%
1.7	2	0.1%
1.79	1	< 0.1%

Value	Count	Frequency (%)
168469.6	1	< 0.1%
22998.4	1	< 0.1%
14688.24	1	< 0.1%
8511.15	1	< 0.1%
7443.59	1	< 0.1%
5228.4	1	< 0.1%
4815.26	1	< 0.1%
4814.74	1	< 0.1%
4486.24	1	< 0.1%
4429	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1979
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.81376

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.25
median	172.33333
Q3	281.69231
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.44231

Descriptive statistics

Standard deviation	791.55519
Coefficient of variation (CV)	3.1685812
Kurtosis	2255.5382
Mean	249.81376
Median Absolute Deviation (MAD)	83.083333
Skewness	44.672717
Sum	741697.07
Variance	626559.62
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
82	9	0.3%
86	9	0.3%
60	8	0.3%
88	8	0.3%
75	8	0.3%
136	8	0.3%
208	7	0.2%
Other values (1969)	2882	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

unique_avg_basket
Real number (ℝ)

HIGH CORRELATION

Distinct	1005
Distinct (%)	33.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.154708

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3.3454545
Q1	10
median	17.2
Q3	27.75
95-th percentile	56.94
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.75

Descriptive statistics

Standard deviation	19.512322
Coefficient of variation (CV)	0.88073027
Kurtosis	27.703297
Mean	22.154708
Median Absolute Deviation (MAD)	8.2
Skewness	3.4994559
Sum	65777.329
Variance	380.73071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	53	1.8%
14	39	1.3%
11	38	1.3%
20	33	1.1%
9	33	1.1%
1	32	1.1%
17	31	1.0%
18	30	1.0%
10	30	1.0%
5	29	1.0%
Other values (995)	2621	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

delta_buy_return
Real number (ℝ)

HIGH CORRELATION

Distinct	2952
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2616.9001

Minimum	-796.86
Maximum	278778.02
Zeros	8
Zeros (%)	0.3%
Negative	3
Negative (%)	0.1%
Memory size	46.4 KiB

Quantile statistics

Minimum	-796.86
5-th percentile	213
Q1	551.54
median	1054.73
Q3	2265.12
95-th percentile	7017.35
Maximum	278778.02
Range	279574.88
Interquartile range (IQR)	1713.58

Descriptive statistics

Standard deviation	9927.6384
Coefficient of variation (CV)	3.7936635
Kurtosis	422.03959
Mean	2616.9001
Median Absolute Deviation (MAD)	656.03
Skewness	18.204198
Sum	7769576.3
Variance	98558004
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	0.3%
178.96	2	0.1%
1078.96	2	0.1%
331	2	0.1%
599.9	2	0.1%
306.55	2	0.1%
379.65	2	0.1%
589.15	2	0.1%
598.2	2	0.1%
582.9	2	0.1%
Other values (2942)	2943	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-796.86	1	< 0.1%
-141.48	1	< 0.1%
-95.93	1	< 0.1%
0	8	0.3%
5.684341886 × 10^-14	1	< 0.1%
4.547473509 × 10^-13	1	< 0.1%
2.9	1	< 0.1%
12.24	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
133007.13	1	< 0.1%
123638.18	1	< 0.1%
114505.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	avg_basket_size	avg_recency_days	avg_ticket	customer_id	delta_buy_return	frequency	gross_revenue	items_purchased	monetary_returns	number_returns	purchases	recency_days	unique_avg_basket	unique_products_purchased
avg_basket_size	1.000	-0.077	0.824	-0.123	0.568	0.027	0.574	0.729	0.179	0.178	0.100	-0.098	0.447	0.383
avg_recency_days	-0.077	1.000	-0.113	0.019	-0.238	-0.881	-0.247	-0.227	-0.397	-0.421	-0.259	0.108	0.048	-0.166
avg_ticket	0.824	-0.113	1.000	-0.141	0.663	0.056	0.674	0.622	0.258	0.244	0.107	-0.073	0.425	0.374
customer_id	-0.123	0.019	-0.141	1.000	-0.072	-0.002	-0.076	-0.070	-0.056	-0.049	0.026	0.001	-0.007	0.013
delta_buy_return	0.568	-0.238	0.663	-0.072	1.000	0.083	0.992	0.921	0.329	0.363	0.774	-0.418	0.299	0.752
frequency	0.027	-0.881	0.056	-0.002	0.083	1.000	0.090	0.080	0.239	0.236	0.079	0.018	-0.072	0.036
gross_revenue	0.574	-0.247	0.674	-0.076	0.992	0.090	1.000	0.925	0.372	0.391	0.770	-0.415	0.291	0.744
items_purchased	0.729	-0.227	0.622	-0.070	0.921	0.080	0.925	1.000	0.326	0.350	0.716	-0.408	0.320	0.730
monetary_returns	0.179	-0.397	0.258	-0.056	0.329	0.239	0.372	0.326	1.000	0.943	0.295	-0.119	0.017	0.242
number_returns	0.178	-0.421	0.244	-0.049	0.363	0.236	0.391	0.350	0.943	1.000	0.338	-0.143	0.031	0.279
purchases	0.100	-0.259	0.107	0.026	0.774	0.079	0.770	0.716	0.295	0.338	1.000	-0.502	0.025	0.690
recency_days	-0.098	0.108	-0.073	0.001	-0.418	0.018	-0.415	-0.408	-0.119	-0.143	-0.502	1.000	-0.106	-0.435
unique_avg_basket	0.447	0.048	0.425	-0.007	0.299	-0.072	0.291	0.320	0.017	0.031	0.025	-0.106	1.000	0.699
unique_products_purchased	0.383	-0.166	0.374	0.013	0.752	0.036	0.744	0.730	0.242	0.279	0.690	-0.435	0.699	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	purchases	unique_products_purchased	items_purchased	avg_ticket	avg_recency_days	frequency	number_returns	monetary_returns	avg_basket_size	unique_avg_basket	delta_buy_return
0	17850	5391.21	372.0	34.0	297.0	1733.0	158.565000	35.500000	17.000000	1.0	102.58	50.970588	8.735294	5288.63
1	13047	3232.59	56.0	9.0	171.0	1390.0	359.176667	27.250000	0.028302	7.0	143.49	154.444444	19.000000	3089.10
2	12583	6705.38	2.0	15.0	232.0	5028.0	447.025333	23.187500	0.040323	2.0	76.04	335.200000	15.466667	6629.34
3	13748	948.25	95.0	5.0	28.0	439.0	189.650000	92.666667	0.017921	0.0	0.00	87.800000	5.600000	948.25
4	15100	876.00	333.0	3.0	3.0	80.0	292.000000	8.600000	0.073171	3.0	240.90	26.666667	1.000000	635.10
5	15291	4623.30	25.0	14.0	102.0	2102.0	330.235714	23.200000	0.040115	5.0	71.79	150.142857	7.285714	4551.51
6	14688	5630.87	7.0	21.0	327.0	3621.0	268.136667	18.300000	0.057221	6.0	523.49	172.428571	15.571429	5107.38
7	17809	5411.91	16.0	12.0	61.0	2057.0	450.992500	35.700000	0.033520	2.0	67.06	171.416667	5.083333	5344.85
8	15311	60767.90	0.0	91.0	2379.0	38194.0	667.779121	4.144444	0.243316	27.0	1348.56	419.714286	26.142857	59419.34
9	16098	2005.63	87.0	7.0	67.0	613.0	286.518571	47.666667	0.024390	0.0	0.00	87.571429	9.571429	2005.63

	customer_id	gross_revenue	recency_days	purchases	unique_products_purchased	items_purchased	avg_ticket	avg_recency_days	frequency	number_returns	monetary_returns	avg_basket_size	unique_avg_basket	delta_buy_return
5627	17727	1060.25	15.0	1.0	66.0	645.0	1060.250000	6.0	1.000000	1.0	17.70	645.000000	66.0	1042.55
5637	17232	421.52	2.0	2.0	36.0	203.0	210.760000	12.0	0.153846	0.0	0.00	101.500000	18.0	421.52
5638	17468	137.00	10.0	2.0	5.0	116.0	68.500000	4.0	0.400000	0.0	0.00	58.000000	2.5	137.00
5649	13596	697.04	5.0	2.0	166.0	406.0	348.520000	7.0	0.250000	0.0	0.00	203.000000	83.0	697.04
5655	14893	1237.85	9.0	2.0	73.0	799.0	618.925000	2.0	0.666667	0.0	0.00	399.500000	36.5	1237.85
5659	12479	473.20	11.0	1.0	30.0	382.0	473.200000	4.0	1.000000	2.0	49.90	382.000000	30.0	423.30
5680	14126	706.13	7.0	3.0	15.0	508.0	235.376667	3.0	0.750000	1.0	62.50	169.333333	5.0	643.63
5686	13521	1092.39	1.0	3.0	435.0	733.0	364.130000	4.5	0.300000	0.0	0.00	244.333333	145.0	1092.39
5696	15060	301.84	8.0	4.0	120.0	262.0	75.460000	1.0	2.000000	0.0	0.00	65.500000	30.0	301.84
5715	12558	269.96	7.0	1.0	11.0	196.0	269.960000	6.0	1.000000	1.0	269.96	196.000000	11.0	0.00

Overview

Variables

Interactions

Correlations

Missing values

Sample